Tabela PhStOrderItem

Definicja tabeli PhStOrderItem

Name

PhStOrderItem

Code

PhStOrderItem

Comment

Elementy zamówien wewnetrznych


Lista kolumn tabeli PhStOrderItem

Name

Code

StOrderItemID

StOrderItemID

StOrderItemStatusID

StOrderItemStatusID

StOrderID

StOrderID

ResourceID

ResourceID

StOrderItemChangeID

StOrderItemChangeID

StItemID

StItemID

DrugAliasID

DrugAliasID

PresentationUnitID

PresentationUnitID

AdministrationDT

AdministrationDT

DoNotChange

DoNotChange

DrugName

DrugName

CommissionResourceID

CommissionResourceID

PatientID

PatientID

DoctorID

DoctorID

Quantity

Quantity

ItemNo

ItemNo

QtyInWords

QtyInWords

ApplicationWayID

ApplicationWayID

PerfResourceID

PerfResourceID

Comments

Comments

OfferPriceGross

OfferPriceGross

BenefitPlanContractID

BenefitPlanContractID

ExternalNo

ExternalNo


Kolumna StOrderItemID tabeli PhStOrderItem

Definicja kolumny StOrderItemID tabeli PhStOrderItem

Name

StOrderItemID

Code

StOrderItemID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderItemStatusID tabeli PhStOrderItem

Definicja kolumny StOrderItemStatusID tabeli PhStOrderItem

Name

StOrderItemStatusID

Code

StOrderItemStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StOrderID tabeli PhStOrderItem

Definicja kolumny StOrderID tabeli PhStOrderItem

Name

StOrderID

Code

StOrderID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna ResourceID tabeli PhStOrderItem

Definicja kolumny ResourceID tabeli PhStOrderItem

Name

ResourceID

Code

ResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StOrderItemChangeID tabeli PhStOrderItem

Definicja kolumny StOrderItemChangeID tabeli PhStOrderItem

Name

StOrderItemChangeID

Code

StOrderItemChangeID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna StItemID tabeli PhStOrderItem

Definicja kolumny StItemID tabeli PhStOrderItem

Name

StItemID

Code

StItemID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna DrugAliasID tabeli PhStOrderItem

Definicja kolumny DrugAliasID tabeli PhStOrderItem

Name

DrugAliasID

Code

DrugAliasID

Data Type

NUMBER(10)

Mandatory

No

Comment

 


Kolumna PresentationUnitID tabeli PhStOrderItem

Definicja kolumny PresentationUnitID tabeli PhStOrderItem

Name

PresentationUnitID

Code

PresentationUnitID

Data Type

NUMBER(10)

Mandatory

No

Comment

id jednostki wybranej / prezentowanej uzytkownikowi przy pozycji


Kolumna AdministrationDT tabeli PhStOrderItem

Definicja kolumny AdministrationDT tabeli PhStOrderItem

Name

AdministrationDT

Code

AdministrationDT

Data Type

DATE

Mandatory

No

Comment

Data podania


Kolumna DoNotChange tabeli PhStOrderItem

Definicja kolumny DoNotChange tabeli PhStOrderItem

Name

DoNotChange

Code

DoNotChange

Data Type

NUMBER(3)

Mandatory

No

Comment

Flaga niezamienialnosci leku


Kolumna DrugName tabeli PhStOrderItem

Definicja kolumny DrugName tabeli PhStOrderItem

Name

DrugName

Code

DrugName

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Alias leku


Kolumna CommissionResourceID tabeli PhStOrderItem

Definicja kolumny CommissionResourceID tabeli PhStOrderItem

Name

CommissionResourceID

Code

CommissionResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zasobu ze zlecenia zewnetrznego


Kolumna PatientID tabeli PhStOrderItem

Definicja kolumny PatientID tabeli PhStOrderItem

Name

PatientID

Code

PatientID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID pacjenta


Kolumna DoctorID tabeli PhStOrderItem

Definicja kolumny DoctorID tabeli PhStOrderItem

Name

DoctorID

Code

DoctorID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID lekarza


Kolumna Quantity tabeli PhStOrderItem

Definicja kolumny Quantity tabeli PhStOrderItem

Name

Quantity

Code

Quantity

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Ilosc


Kolumna ItemNo tabeli PhStOrderItem

Definicja kolumny ItemNo tabeli PhStOrderItem

Name

ItemNo

Code

ItemNo

Data Type

NUMBER(10)

Mandatory

No

Comment

Liczba porzadkowa


Kolumna QtyInWords tabeli PhStOrderItem

Definicja kolumny QtyInWords tabeli PhStOrderItem

Name

QtyInWords

Code

QtyInWords

Data Type

VARCHAR2(255)

Mandatory

No

Comment

Zamawiana ilosc slownie. Dotyczy narkotyków i psychotropów.


Kolumna ApplicationWayID tabeli PhStOrderItem

Definicja kolumny ApplicationWayID tabeli PhStOrderItem

Name

ApplicationWayID

Code

ApplicationWayID

Data Type

NUMBER(10)

Mandatory

No

Comment

Kolumna ID drogi podania leku


Kolumna PerfResourceID tabeli PhStOrderItem

Definicja kolumny PerfResourceID tabeli PhStOrderItem

Name

PerfResourceID

Code

PerfResourceID

Data Type

NUMBER(10)

Mandatory

No

Comment

ID zewnetrznego zasobu ze zlecenia


Kolumna Comments tabeli PhStOrderItem

Definicja kolumny Comments tabeli PhStOrderItem

Name

Comments

Code

Comments

Data Type

VARCHAR2(4000)

Mandatory

No

Comment

Przyczyna anulowania zamówienia


Kolumna OfferPriceGross tabeli PhStOrderItem

Definicja kolumny OfferPriceGross tabeli PhStOrderItem

Name

OfferPriceGross

Code

OfferPriceGross

Data Type

NUMBER(19,8)

Mandatory

No

Comment

Cena z umowy w pozycji zamówienia


Kolumna BenefitPlanContractID tabeli PhStOrderItem

Definicja kolumny BenefitPlanContractID tabeli PhStOrderItem

Name

BenefitPlanContractID

Code

BenefitPlanContractID

Data Type

NUMBER(10)

Mandatory

No

Comment

Zrodlo finansowania


Kolumna ExternalNo tabeli PhStOrderItem

Definicja kolumny ExternalNo tabeli PhStOrderItem

Name

ExternalNo

Code

ExternalNo

Data Type

VARCHAR2(50)

Mandatory

No

Comment

Numer zlecenia z systemu zewnetrznego


Lista kluczy tabeli PhStOrderItem

Name

Code

Primary

Key_1

Key_1

X


Klucz Key_1 tabeli PhStOrderItem

Definicja klucza Key_1 tabeli PhStOrderItem

Name

Key_1

Code

Key_1

Primary

Yes

Comment